package com.huikeportal.dao;

import java.util.List;
import com.huikeportal.model.BrandModel;
import com.huikeportal.model.DpModel;
import com.huikeportal.model.GcModel;
import com.huikeportal.model.QyModel;
import com.huikeportal.model.RegionModel;
import com.huikeportal.model.SiteAllInfo;
import com.huikeportal.model.SiteCommon;
import com.huikeportal.model.SiteIndex;
import com.huikeportal.model.SiteSimpleInfo;
import com.huikeportal.model.UserSiteHistory;
import com.huikeportal.model.common.PageDataVo;
import com.huikeportal.model.common.SqlParameter;

public interface SelectSiteMapper {

	List<SiteAllInfo> queryGcList(GcModel gcModel) throws Exception;

	List<GcModel> queryDqList(GcModel gcModel) throws Exception;

	List<SiteAllInfo> queryDpListByPage(PageDataVo pageDataVo) throws Exception;

	int queryDpCountByPage(PageDataVo pageDataVo) throws Exception;

	List<GcModel> querySqList(GcModel gcModel) throws Exception;

	List<SiteAllInfo> queryLcList(SqlParameter sqlParameter) throws Exception;

	List<SiteAllInfo> queryLcListByPage(PageDataVo pageDataVo) throws Exception;

	int queryLcCountByPage(PageDataVo pageDataVo) throws Exception;

	List<SiteAllInfo> queryTdListByPage(PageDataVo pageDataVo) throws Exception;

	int queryTdCountByPage(PageDataVo pageDataVo) throws Exception;

	SiteCommon querySiteInfo(String siteId) throws Exception;

	List<SiteAllInfo> queryLcByGc(String string) throws Exception;

	List<SiteAllInfo> queryQyByGc(String string) throws Exception;

	SiteIndex queryIsHaveIndex(String string) throws Exception;

	List<SiteAllInfo> queryQyList(QyModel qyModel) throws Exception;

	List<SiteAllInfo> queryQyListByPage(PageDataVo pageDataVo) throws Exception;

	int queryQyCountByPage(PageDataVo pageDataVo) throws Exception;

	List<SiteAllInfo> queryQyListExcel(RegionModel regionModel)
			throws Exception;

	List<SiteAllInfo> queryLcListExcel(RegionModel regionModel)
			throws Exception;

	List<SiteAllInfo> queryDpListExcel(RegionModel regionModel)
			throws Exception;

	List<SiteAllInfo> queryDpList(DpModel dpModel) throws Exception;

	List<SiteAllInfo> selectLcByDp(String string) throws Exception;

	List<SiteAllInfo> selectGcByDp(String string) throws Exception;

	List<SiteAllInfo> selectPpByDp(String string) throws Exception;

	Integer queryMenuIdByAddress(SqlParameter sql) throws Exception;

	Integer queryHistoryId(UserSiteHistory userSiteHistory) throws Exception;

	List<SiteAllInfo> selectGuojiaCombo() throws Exception;

	List<SiteAllInfo> selectShengCombo(Integer id) throws Exception;

	List<SiteAllInfo> selectShiCombo(Integer id) throws Exception;

	List<SiteAllInfo> selectQuCombo(Integer id) throws Exception;

	List<SiteAllInfo> pinjieGc(String string) throws Exception;

	List<SiteAllInfo> mulSelectDp(DpModel dpModel) throws Exception;

	List<SiteAllInfo> mulSelectLc(SqlParameter sql) throws Exception;

	List<SiteAllInfo> mulSelectQy(QyModel qyModel) throws Exception;

	// 查询区域客流-广场下的区域
	List<SiteSimpleInfo> getGcQyInQy(String string) throws Exception;

	// 查询区域客流-区域下的区域
	List<SiteSimpleInfo> getQyQyInQy(String string) throws Exception;

	// 查询区域客流-楼层下的区域
	List<SiteSimpleInfo> getLcQyInQy(String string) throws Exception;

	// 查询区域客流-店铺下的区域
	List<SiteSimpleInfo> getDpQyInQy(SqlParameter sql) throws Exception;

	// 查询楼层客流-广场下的楼层
	List<SiteSimpleInfo> getGcLcInLc(String string) throws Exception;

	// 查询楼层客流-区域下的楼层
	List<SiteSimpleInfo> getQyLcInLc(String string) throws Exception;

	// 查询楼层客流-楼层下的楼层
	List<SiteSimpleInfo> getLcLcInLc(String string) throws Exception;

	// 查询楼层客流-店铺下的楼层
	List<SiteSimpleInfo> getDpLcInLc(SqlParameter sql) throws Exception;

	// 2015年12月28日13:47:43新增通道概览
	// 查询通道客流-广场下的通道
	List<SiteSimpleInfo> getGcTdInTd(String string) throws Exception;

	// 查询通道客流-区域下的通道
	List<SiteSimpleInfo> getQyTdInTd(String string) throws Exception;

	// 查询通道客流-楼层下的通道
	List<SiteSimpleInfo> getLcTdInTd(String string) throws Exception;

	// 查询通道客流-店铺下的通道
	List<SiteSimpleInfo> getDpTdInTd(SqlParameter sql) throws Exception;

	// 查询店铺客流-广场下的店铺
	List<SiteSimpleInfo> getGcDpInDp(SqlParameter sql) throws Exception;

	// 查询店铺客流-区域下的店铺
	List<SiteSimpleInfo> getQyDpInDp(String string) throws Exception;

	// 查询店铺客流-楼层下的店铺
	List<SiteSimpleInfo> getLcDpInDp(String string) throws Exception;

	// 查询店铺客流-店铺下的店铺
	List<SiteSimpleInfo> getDpDpInDp(SqlParameter sql) throws Exception;

	// 查询用户集团-地区列表
	List<SiteAllInfo> getJtDqList(SqlParameter sql) throws Exception;

	// 根据场所id查询场所信息
	List<SiteSimpleInfo> getSimpleSiteList(String string) throws Exception;

	// 查询区域
	List<SiteAllInfo> getTwiceQy(RegionModel regionModel) throws Exception;

	// 查询楼层
	List<SiteAllInfo> getTwiceLc(RegionModel regionModel) throws Exception;

	// 查询店铺
	List<SiteAllInfo> getTwiceDp(RegionModel regionModel) throws Exception;

	// 查询品牌
	List<BrandModel> queryBrandByGc(BrandModel brandModel) throws Exception;
}
